﻿CREATE PROCEDURE [dbo].[usp_Tier_Tbl_Ins]
@Tier nvarchar(50), 
@CostFactor float, 
@TPI nvarchar(50), 
@UsageTypeID int, 
@TierCode nvarchar(50)	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	INSERT INTO Tier_Tbl (Tier, CostFactor, TierPriceIndicator, UsageTypeID, TierCode) VALUES (@Tier, @CostFactor, @TPI, @UsageTypeID, @TierCode)
END